﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ZhimeiSoft.Framework.Common.TableInfo
{
    /// <summary>
    /// 预约表
    /// </summary>
    public class DBSchedule : DBBaseInfo
    {
        /// <summary>
        /// 表名称
        /// </summary>
        /// <returns></returns>
        public override string GetTableName()
        {
            return base.GetTableName();
        }
        /// <summary>
        /// 预约ID
        /// </summary>
        public int SCHEDUEID { get; set; }
        /// <summary>
        /// 店ID
        /// </summary>
        public int SALONID { get; set; }
        /// <summary>
        /// 会员ID
        /// </summary>
        public int CUSTOMID { get; set; }
        /// <summary>
        /// 预约开始时间
        /// </summary>
        public DateTime SCHEDULETIME { get; set; }
        /// <summary>
        /// 系统完成时间 如果预约成功（SOF）系统自动记录当前时间
        /// </summary>
        public DateTime SYSTIME { get; set; }
        /// <summary>
        /// 预约状态 S0P 预约计划中 S0F 预约成功 SOE 预约超时
        /// </summary>
        public string STATE { get; set; }
        /// <summary>
        /// 预约计划开始时间
        /// </summary>
        public DateTime SPLANSTARTTIME { get; set; }
        /// <summary>
        /// 预约计划结束时间
        /// </summary>
        public DateTime SPLANENDTIME { get; set; }
        /// <summary>
        /// 提醒类型该类型只能在SOP 状态有效，SH每小时提醒 SD 每天提醒 SW 每周提醒 
        /// SM 每月提醒 SDH 定时提醒，下次提醒的时间存放在ScheduleTime
        /// </summary>
        public string SPLANTIMESTATE { get; set; }
        /// <summary>
        /// 备注说明
        /// </summary>
        public string SPLANMEMO { get; set; }

        /// <summary>
        /// 字段名
        /// </summary>
        public static class FieldName
        {
            /// <summary>
            /// 预约ID
            /// </summary>
            public const string SCHEDUEID = "SCHEDUEID";
            /// <summary>
            /// 店ID
            /// </summary>
            public const string SALONID = "SALONID";
            /// <summary>
            /// 会员ID
            /// </summary>
            public const string CUSTOMID = "CUSTOMID";
            /// <summary>
            /// 预约开始时间
            /// </summary>
            public const string SCHEDULETIME = "SCHEDULETIME";
            /// <summary>
            /// 系统完成时间 如果预约成功（SOF）系统自动记录当前时间
            /// </summary>
            public const string SYSTIME = "SYSTIME";
            /// <summary>
            /// 预约状态 S0P 预约计划中 S0F 预约成功 SOE 预约超时
            /// </summary>
            public const string STATE = "STATE";
            /// <summary>
            /// 预约计划开始时间
            /// </summary>
            public const string SPLANSTARTTIME = "SPLANSTARTTIME";
            /// <summary>
            /// 预约计划结束时间
            /// </summary>
            public const string SPLANENDTIME = "SPLANENDTIME";
            /// <summary>
            /// 提醒类型该类型只能在SOP 状态有效，SH每小时提醒 SD 每天提醒 SW 每周提醒 
            /// SM 每月提醒 SDH 定时提醒，下次提醒的时间存放在ScheduleTime
            /// </summary>
            public const string SPLANTIMESTATE = "SPLANTIMESTATE";
            /// <summary>
            /// 备注说明
            /// </summary>
            public const string SPLANMEMO = "SPLANMEMO";
        }
        /// <summary>
        ///预约状态 S0P 预约计划中 S0F 预约成功 SOE 预约超时
        /// </summary>
        public static class ENUM_STATE{
            /// <summary>
            /// S0P 预约计划中
            /// </summary>
            public const string SOP = "SOP"; 
            /// <summary>
            ///  S0F 预约成功
            /// </summary>
            public const string SOF = "SOF"; 
            /// <summary>
            /// SOE 预约超时
            /// </summary>
            public const string SOE = "SOE";
        }; 

        /// <summary>
        /// 提醒类型该类型只能在SOP 状态有效，SH每小时提醒 SD 每天提醒 SW 每周提醒 
        /// SM 每月提醒 SDH 定时提醒，下次提醒的时间存放在ScheduleTime
        /// </summary>
        public static class ENUM_SPLANTIMESTATE{
            /// <summary>
            /// SH每小时提醒
            /// </summary>
            public const string SH = "SH";
            /// <summary>
            /// SD 每天提醒
            /// </summary>
            public const string SD = "SD";
            /// <summary>
            /// SW 每周提醒
            /// </summary>
            public const string SW = "SW";
            /// <summary>
            /// SM 每月提醒
            /// </summary>
            public const string SM = "SM";
            /// <summary>
            /// SDH 定时提醒
            /// </summary>
            public const string SDH = "SDH";
        }
    }
}
